![]() | ![]() | ![]() | ![]() | ![]() |
When reading numeric data into SAS®, it is often helpful to assign characters in your input data to represent special missing values for numeric data. The MISSING statement specifies the value in your input data that represents a special missing value. This can be any of the letters of the alphabet or the underscore character.
The ANYDTDTE, ANYDTDTM, and ANYDTTME informats do not read the special missing values correctly. Instead of showing the letter or underscore from the input data in the output, a period is shown instead.
To circumvent the problem, use a different informat to read the input data that contains special missing values.
The sample code on the Full Code tab illustrates the problem and a circumvention.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | Base SAS | HP-UX IPF | 9.3 TS1M0 | 9.4 TS1M5 |
64-bit Enabled Solaris | 9.3 TS1M0 | 9.4 TS1M5 | ||
64-bit Enabled HP-UX | 9.3 TS1M0 | 9.4 TS1M5 | ||
64-bit Enabled AIX | 9.3 TS1M0 | 9.4 TS1M5 | ||
Windows Vista for x64 | 9.3 TS1M0 | |||
Windows Vista | 9.3 TS1M0 | |||
Windows 7 Ultimate x64 | 9.3 TS1M0 | 9.4 TS1M5 | ||
Windows 7 Ultimate 32 bit | 9.3 TS1M0 | 9.4 TS1M5 | ||
Windows 7 Professional x64 | 9.3 TS1M0 | 9.4 TS1M5 | ||
Windows 7 Professional 32 bit | 9.3 TS1M0 | 9.4 TS1M5 | ||
Windows 7 Home Premium x64 | 9.3 TS1M0 | 9.4 TS1M5 | ||
Windows 7 Home Premium 32 bit | 9.3 TS1M0 | 9.4 TS1M5 | ||
Windows 7 Enterprise x64 | 9.3 TS1M0 | 9.4 TS1M5 | ||
Windows 7 Enterprise 32 bit | 9.3 TS1M0 | 9.4 TS1M5 | ||
Microsoft Windows XP Professional | 9.3 TS1M0 | |||
Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | |||
Microsoft Windows Server 2008 R2 | 9.3 TS1M0 | |||
Microsoft Windows Server 2008 | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | |||
Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.4 TS1M5 | ||
z/OS 64-bit | 9.3 TS1M0 | 9.4 TS1M5 | ||
z/OS | 9.3 TS1M0 | 9.4 TS1M5 | ||
Linux | 9.3 TS1M0 | 9.4 TS1M5 | ||
Linux for x64 | 9.3 TS1M0 | 9.4 TS1M5 | ||
Solaris for x64 | 9.3 TS1M0 | 9.4 TS1M5 |